These files are free to download. If you find this usable, please make a donation to:

                 Thomas Lundqvist Consulting.

The par.sql Script

This script will give a list of all v$parameter values.

 

Syntax: @par <partial parameter name>

 

                 par.sql

 

The ext.sql Script

The ext script will do an source extract of all found database objects. 

 

Syntax: @ext <partial object name>

 

self-extracting Zip:

 

                 ext.exe

 

… or the zip file:

ext.zip

 

 

The “Excel SQL for Oracle Applications”:

Excel sheet to get oracle applications data into a excel sheet:

 

                 Sql_v6.xls

 

The “Excel for Oracle Applications / concurrent program”:

Excel sheet to start concurrent requests. Perfect for structured unit testing of reports. You can easily submit several requests with different parameters. When completed, out and log files is ftp’ed to your workstation.

 

xxtlq_submit_v10.xls

 

… and the readme/quickstart document:

 

xxtlq_submit_v10.txt

 

TrainMath - Excel Math Training

Excel application to random generate math assignments with graded difficulty.

 

TrainMath_v1.xls

 

Downloads

Last updated: 15-06-2008 22:54

Thomas Lundqvist Consulting

Oracle Applications Developer

The Apps Initialize Script

This will present you with all your responsibilites  and let you select one.  Put it in your login.sql to do apps initialize when starting sql*plus.  Pls. verify your language setting—if it is wrong the script wont find anything (use “ALTER SESSION SET NLS_LANGUAGE= 'AMERICAN'; “

 

 

Syntax: @ai <username>

 

                 ai.sql

 

The login.sql Script

If you put this script in the start directory of sql*plus, it will do the things you want every time you start sql*plus. Like set serveroutput on, apps initialize, display the connect string. You need to edit the file for your purpose.

 

                 login.sql

 

The info.sql Script

This script will list all fnd_globals, current set of books and the ar_system_parameters.

 

Syntax: @info

 

                 info.sql

 

The obj.sql Script

This script will do a fast search on all database objects. @obj fnd will find all fnd% database objects. Also shows if object is invalid.

 

Syntax: @obj <partial object name>

 

                 obj.sql

 

The org.sql Script

This script will give a list of all org_id’s  

 

Syntax: @org

 

                 org.sql

 

The sob.sql Script

This script will give a list of all set_of_books_id’s  

 

Syntax: @sob

 

                 sob.sql

 

The csob.sql Script

This script will give a list of the current set_of_books_id. Use after apps_initialize.

 

Syntax: @csob

 

csob.sql